<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 19:58:38-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Inventory']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>NetApp SAN and NAS Capacity Summary</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell colSpan="1"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="width:5px;background-color:#F7F7F7"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total SAN Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Capacity SQL">
			<contents><textItem><dataSource><dataItemValue refDataItem="SAN Allocated (TB)"/></dataSource><style><CSS value="font-size:36px;color:#808080;font-weight:bold;font-family:Arial"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;vertical-align:top;background-color:#F7F7F7;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px;background-color:#F7F7F7"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total NAS Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="Capacity SQL">
			<contents><textItem><dataSource><dataItemValue refDataItem="NAS Allocated (TB)"/></dataSource><style><CSS value="font-size:36px;color:#808080;font-weight:bold;font-family:Arial"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;vertical-align:top;background-color:#F7F7F7;border-right:1.5pt solid #ADB2B5"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total Allocated Raw</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Capacity SQL">
			<contents><textItem><dataSource><dataItemValue refDataItem="Raw Capacity (TB)"/></dataSource><style><CSS value="color:#808080;font-weight:bold;font-style:normal;font-family:Arial;font-size:36px"/><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;vertical-align:top;background-color:#F7F7F7;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px;background-color:#F7F7F7"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total SAN and NAS</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565;width:140px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="Capacity SQL">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total SAN and NAS Capacity (TB)"/></dataSource><style><CSS value="color:#808080;font-weight:bold;font-style:normal;font-family:Arial;font-size:36px"/><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;vertical-align:top;background-color:#F7F7F7;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px;background-color:#F7F7F7"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>SAN Free Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton6" refQuery="Capacity SQL">
			<contents><textItem><dataSource><dataItemValue refDataItem="SAN Free (TB)"/></dataSource><style><CSS value="color:#808080;font-weight:bold;font-style:normal;font-family:Arial;font-size:36px"/><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;vertical-align:top;background-color:#F7F7F7;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px;background-color:#F7F7F7"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>NAS Free Capacity</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="Capacity SQL">
			<contents><textItem><dataSource><dataItemValue refDataItem="NAS Free (TB)"/></dataSource><style><CSS value="color:#808080;font-weight:bold;font-style:normal;font-family:Arial;font-size:36px"/><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;vertical-align:top;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents>
												<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>SAN and NAS</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Storage Array)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart9" refQuery="Capacity SQL">
														<v2_combinationTypeTooltips/>
														<v2_commonAxis>
															<v2_ordinalAxis autoTruncation="false" manualTruncationMaxChars="12" truncationText="...">
																<v2_axisLabels>
																	<style>
																		<defaultStyles>
																			<defaultStyle refStyle="al"/>
																		</defaultStyles>
																	<CSS value="color:#454545"/></style>
																</v2_axisLabels>
																</v2_ordinalAxis>
															<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Storage Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="SAN Allocated (TB)"/><sortItem refDataItem="NAS Allocated (TB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
														<v2_topLeftAxis>
															<v2_combinationChartTypes>
																<v2_bar barShape="box" bevel="none" seriesType="stacked" setOrdinalWidthScale="80" borderColor="white">
																	<!-- v2_solidPaletteRef ref=&amp;amp;quot;gDefaultSolid&amp;amp;quot;/ -->
																	<v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="NAS Allocated (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="SAN Allocated (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
															</v2_combinationChartTypes>
															<v2_axis>
																<v2_axisRange>
																	<v2_automaticRange/>
																</v2_axisRange>
																<v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
                                                                                        </v2_axisLabels><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
														</v2_topLeftAxis>
														<style>
															<CSS value="width:620px;height:300px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
														<noDataHandler>
															<contents>
																<block>
																	<contents>
																		<textItem>
																			<dataSource>
																				<staticValue>No Data Available</staticValue>
																			</dataSource>
																			<style>
																				<CSS value="padding:10px 18px;"/>
																			</style>
																		</textItem>
																	</contents>
																</block>
															</contents>
														</noDataHandler>
														<chartSuppress type="categories"/><v2_legend><style><defaultStyles><defaultStyle refStyle="lg"/></defaultStyles></style><v2_legendPosition><v2_legendPreset legendPositionPreset="bottom"/></v2_legendPosition></v2_legend></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Aggregates</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(SAN and NAS)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart3" refQuery="Top Aggregates">
														<v2_combinationTypeTooltips/>
														<v2_legend>
															<style>
																<defaultStyles>
																	<defaultStyle refStyle="lg"/>
																</defaultStyles>
															</style>
															<v2_legendPosition><v2_legendPreset legendPositionPreset="bottom"/></v2_legendPosition></v2_legend>
														<v2_commonAxis>
															<v2_ordinalAxis autoTruncation="false" labelDisplayType="concat" manualTruncationMaxChars="15" truncationText="...">
																
																<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
					<dataFormat><percentFormat/></dataFormat><CSS value="color:#454545"/></style>
			</v2_axisLabels></v2_ordinalAxis>
															<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Storage Name"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Storage Pool Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Total SAN and NAS Capacity (TB)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes></v2_commonAxis>
														<v2_topLeftAxis>
															<v2_combinationChartTypes>
																<v2_bar barShape="box" bevel="none" seriesType="stacked" setOrdinalWidthScale="80" borderColor="white">
																	<!-- v2_solidPaletteRef ref=&quot;gDefaultSolid&quot;/ -->
																	<v2_solidPalette>
					<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="NAS Allocated (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="SAN Allocated (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
															</v2_combinationChartTypes>
															<v2_axis>
																<v2_axisRange>
																	<v2_automaticRange/>
																</v2_axisRange>
																<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' TB'"/></dataFormat></style>
			</v2_axisLabels><v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/></v2_axis>
														</v2_topLeftAxis>
														<style>
															<CSS value="width:620px;height:300px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
														<noDataHandler>
															<contents>
																<block>
																	<contents>
																		<textItem>
																			<dataSource>
																				<staticValue>No Data Available</staticValue>
																			</dataSource>
																			<style>
																				<CSS value="padding:10px 18px;"/>
																			</style>
																		</textItem>
																	</contents>
																</block>
															</contents>
														</noDataHandler>
														</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;text-align:left;background-color:#F7F7F7;padding-top:15px;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell colSpan="1"><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>NAS Volumes</staticValue></dataSource></textItem></contents><style><CSS value="color:gray;font-weight:bold;font-style:italic;padding-left:5px;padding-top:5px;border-top:2.25pt ridge #F7F7F7"/></style></tableCell><tableCell><contents/><style><CSS value="border-top:2.25pt ridge #F7F7F7;border-right:2.25pt ridge #F7F7F7"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>SAN Volumes</staticValue></dataSource></textItem></contents><style><CSS value="font-weight:bold;color:gray;font-style:italic;padding-left:10px;padding-top:5px;border-top:2.25pt ridge #F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List1" refQuery="NAS Volumes SQL" rowsPerPage="5000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-weight:bold;color:#454545"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="text-align:left;width:150px;word-wrap:break-word;color:#454545;background-color:white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Storage Name"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-weight:bold;color:#454545"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Pool Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="text-align:left;width:80px;word-wrap:break-word;color:#454545;background-color:white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Pool Name"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Storage Pool Name"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-weight:bold;color:#454545"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Internal Volume Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="text-align:left;width:80px;word-wrap:break-word;color:#454545;background-color:white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Internal Volume Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-weight:bold;color:#454545"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Allocated Capacity GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px;color:#454545;background-color:white"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Allocated Capacity GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-weight:bold;color:#454545"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Used Capacity GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px;color:#454545;background-color:white"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Used Capacity GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-weight:bold;color:#454545"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="NAS Free (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px;color:#454545;background-color:white"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="NAS Free (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Storage Name"/><listGroup refDataItem="Storage Pool Name"/></listGroups></list></contents><style><CSS value="vertical-align:top;padding-right:10px"/></style></tableCell><tableCell><contents/><style><CSS value="border-right:2.25pt ridge #F7F7F7"/></style></tableCell><tableCell><contents><list horizontalPagination="true" name="List2" refQuery="SAN Volumes SQL" rowsPerPage="5000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="width:150px;word-wrap:break-word;color:#454545;background-color:white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Pool Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="width:110px;word-wrap:break-word;color:#454545;background-color:white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Pool Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Volume Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles><CSS value="width:80px;word-wrap:break-word;color:#454545;background-color:white"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Volume Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Allocated Capacity GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px;color:#454545;background-color:white"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Allocated Capacity GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Used Capacity GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px;color:#454545;background-color:white"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Used Capacity GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="SAN Free (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:75px;color:#454545;background-color:white"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="SAN Free (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="padding-left:10px;vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px;vertical-align:top;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.905Z"/></XMLAttributes><reportName>2.21 NetApp SAN and NAS Capacity Summary</reportName><queries><query name="Capacity">
			<source>
				<model/>
			</source>
			<selection><dataItem aggregate="none" name="Storage Name" rollupAggregate="none"><expression>[Storage Assets].[Storage].[Storage Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Storage Pool Name" rollupAggregate="none"><expression>[Storage Assets].[Storage Pool].[Storage Pool Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Internal Volume Name" rollupAggregate="none"><expression>[Storage Assets].[Internal Volume].[Internal Volume Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Volume Name" rollupAggregate="none"><expression>[Storage Assets].[Volume].[Volume Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="total" name="Total Allocated Capacity GB"><expression>[Storage Assets].[Internal Volume].[Total Allocated Capacity GB]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="fact"/></XMLAttributes></dataItem><dataItem aggregate="total" name="Total Used Capacity GB"><expression>[Storage Assets].[Internal Volume].[Total Used Capacity GB]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="fact"/></XMLAttributes></dataItem><dataItem aggregate="total" name="NAS Allocated (TB)"><expression>if([Volume Name] is null) THEN ([Total Allocated Capacity GB]/1024) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="SAN Allocated (TB)"><expression>if([Volume Name] is not null) THEN ([Total Allocated Capacity GB]/1024) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="Total SAN and NAS Capacity (TB)"><expression>[NAS Allocated (TB)]+[SAN Allocated (TB)]</expression></dataItem><dataItem aggregate="total" name="Raw Capacity (TB)"><expression>maximum([Storage Assets].[Storage].[Raw Capacity GB]/1024 for [Storage Name])</expression></dataItem><dataItem aggregate="total" name="NAS Free (TB)"><expression>if([Volume Name] is null) THEN (([Total Allocated Capacity GB]/1024)-([Total Used Capacity GB]/1024)) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="SAN Free (TB)"><expression>if([Volume Name] is not null) THEN (([Total Allocated Capacity GB]/1024)-([Total Used Capacity GB]/1024)) ELSE (0)</expression></dataItem><dataItem name="Model" aggregate="none" rollupAggregate="none"><expression>[Storage Assets].[Storage].[Model]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Model] contains 'FAS'</filterExpression></detailFilter></detailFilters></query><query name="Top Thin Pools">
			<source>
				
			<sqlQuery dataSource="dwh_capacity" name="SQL2">
			<sqlText>select
dwh_capacity.storage_dimension.name as 'Storage Name',
dwh_capacity.storage_pool_dimension.name as 'Pool Name',
dwh_capacity.storage_pool_dimension.thinProvisioningSupported as 'Thin Supported',
dwh_capacity.storage_dimension.manufacturer as 'Vendor',
dwh_capacity.storage_dimension.family as 'Family',
sum(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB/1048576) as 'Usable TB',
sum(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB/1048576) as 'Used TB',
sum(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB/1048576) as 'Volume TB',
sum(dwh_capacity.storage_and_storage_pool_capacity_fact.internalVolumeAllocatedCapacityMB/1048576) as 'Internal Volume TB',
dwh_capacity.date_dimension.fulldate as 'Full Date'

FROM	dwh_capacity.storage_and_storage_pool_capacity_fact 	
JOIN	dwh_capacity.storage_dimension
ON	dwh_capacity.storage_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagetk
AND 	dwh_capacity.storage_dimension.model LIKE CONCAT('%','FAS','%')
JOIN	dwh_capacity.storage_pool_dimension
ON	dwh_capacity.storage_pool_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.storagepooltk
JOIN	dwh_capacity.date_dimension
ON	dwh_capacity.date_dimension.tk=dwh_capacity.storage_and_storage_pool_capacity_fact.datetk


WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN dwh_capacity.storage_and_storage_pool_capacity_fact 
ON dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY dwh_capacity.storage_pool_dimension.name, dwh_capacity.storage_dimension.name, dwh_capacity.date_dimension.fulldate</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Pool Name"/><mdProjectedItem name="Thin Supported"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Family"/><mdProjectedItem name="Usable TB"/><mdProjectedItem name="Used TB"/><mdProjectedItem name="Volume TB"/><mdProjectedItem name="Internal Volume TB"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL2].[Storage Name]</expression></dataItem><dataItem name="Pool Name"><expression>[SQL2].[Pool Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL2].[Vendor]</expression></dataItem><dataItem name="Family"><expression>[SQL2].[Family]</expression></dataItem><dataItem name="Usable TB"><expression>[SQL2].[Usable TB]</expression></dataItem><dataItem name="Used TB"><expression>[SQL2].[Used TB]</expression></dataItem><dataItem name="Volume TB"><expression>[SQL2].[Volume TB]</expression></dataItem><dataItem name="Internal Volume TB"><expression>[SQL2].[Internal Volume TB]</expression></dataItem><dataItem aggregate="total" name="Thin Allocated %"><expression>if([Vendor]='netapp') THEN ([Internal Volume TB]/[Usable TB]) ELSE ([Volume TB]/[Usable TB])</expression></dataItem><dataItem name="Full Date"><expression>[SQL2].[Full Date]</expression></dataItem><dataItem name="Thin Supported"><expression>[SQL2].[Thin Supported]</expression></dataItem><dataItem name="rank"><expression>rank([Pool Name])</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Pool Name]&lt;&gt;'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;11</filterExpression></detailFilter></detailFilters></query><query name="Top Aggregates">
			<source>
				<model/>
			</source>
			<selection><dataItem aggregate="none" name="Storage Name" rollupAggregate="none"><expression>[Storage Assets].[Storage].[Storage Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem name="Model" aggregate="none" rollupAggregate="none"><expression>[Storage Assets].[Storage].[Model]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Storage Pool Name" rollupAggregate="none"><expression>[Storage Assets].[Storage Pool].[Storage Pool Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Internal Volume Name" rollupAggregate="none"><expression>[Storage Assets].[Internal Volume].[Internal Volume Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Volume Name" rollupAggregate="none"><expression>[Storage Assets].[Volume].[Volume Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="total" name="Total Allocated Capacity GB"><expression>[Storage Assets].[Internal Volume].[Total Allocated Capacity GB]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="fact"/></XMLAttributes></dataItem><dataItem aggregate="total" name="Total Used Capacity GB"><expression>[Storage Assets].[Internal Volume].[Total Used Capacity GB]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="fact"/></XMLAttributes></dataItem><dataItem aggregate="total" name="NAS Allocated (TB)"><expression>if([Volume Name] is null) THEN ([Total Allocated Capacity GB]/1024) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="SAN Allocated (TB)"><expression>if([Volume Name] is not null) THEN ([Total Allocated Capacity GB]/1024) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="Total SAN and NAS Capacity (TB)"><expression>[NAS Allocated (TB)]+[SAN Allocated (TB)]</expression></dataItem><dataItem aggregate="total" name="Raw Capacity (TB)"><expression>maximum([Storage Assets].[Storage].[Raw Capacity GB]/1024 for [Storage Name])</expression></dataItem><dataItem aggregate="total" name="NAS Free (TB)"><expression>if([Volume Name] is null) THEN (([Total Allocated Capacity GB]/1024)-([Total Used Capacity GB]/1024)) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="SAN Free (TB)"><expression>if([Volume Name] is not null) THEN (([Total Allocated Capacity GB]/1024)-([Total Used Capacity GB]/1024)) ELSE (0)</expression></dataItem><dataItem name="rank"><expression>rank([Total SAN and NAS Capacity (TB)])</expression></dataItem></selection>
		<detailFilters><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;11</filterExpression></detailFilter></detailFilters></query><query name="SAN Volumes">
			<source>
				<model/>
			</source>
			<selection><dataItem aggregate="none" name="Storage Name" rollupAggregate="none"><expression>[Storage Assets].[Storage].[Storage Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem name="Manufacturer" aggregate="none" rollupAggregate="none"><expression>[Storage Assets].[Storage].[Manufacturer]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Model" aggregate="none" rollupAggregate="none"><expression>[Storage Assets].[Storage].[Model]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Storage Pool Name" rollupAggregate="none"><expression>[Storage Assets].[Storage Pool].[Storage Pool Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Internal Volume Name" rollupAggregate="none"><expression>[Storage Assets].[Internal Volume].[Internal Volume Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Volume Name" rollupAggregate="none"><expression>[Storage Assets].[Volume].[Volume Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="total" name="Total Allocated Capacity GB"><expression>[Storage Assets].[Internal Volume].[Total Allocated Capacity GB]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="fact"/></XMLAttributes></dataItem><dataItem aggregate="total" name="Total Used Capacity GB"><expression>[Storage Assets].[Internal Volume].[Total Used Capacity GB]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="fact"/></XMLAttributes></dataItem><dataItem aggregate="total" name="NAS Allocated (TB)"><expression>if([Volume Name] is null) THEN ([Total Allocated Capacity GB]/1024) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="SAN Allocated (TB)"><expression>if([Volume Name] is not null) THEN ([Total Allocated Capacity GB]/1024) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="Total SAN and NAS Capacity (TB)"><expression>[NAS Allocated (TB)]+[SAN Allocated (TB)]</expression></dataItem><dataItem aggregate="total" name="Raw Capacity (TB)"><expression>maximum([Storage Assets].[Storage].[Raw Capacity GB]/1024 for [Storage Name])</expression></dataItem><dataItem aggregate="total" name="NAS Free (TB)"><expression>if([Volume Name] is null) THEN (([Total Allocated Capacity GB]/1024)-([Total Used Capacity GB]/1024)) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="SAN Free (TB)"><expression>if([Volume Name] is not null) THEN (([Total Allocated Capacity GB]/1024)-([Total Used Capacity GB]/1024)) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="NAS Free (GB)"><expression>if([Volume Name] is null) THEN (([Total Allocated Capacity GB])-([Total Used Capacity GB])) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="SAN Free (GB)"><expression>if([Volume Name] is not null) THEN (([Total Allocated Capacity GB])-([Total Used Capacity GB])) ELSE (0)</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Volume Name] is not null</filterExpression></detailFilter><detailFilter><filterExpression>[Manufacturer]='netapp'</filterExpression></detailFilter></detailFilters></query><query name="NAS Volumes">
			<source>
				<model/>
			</source>
			<selection><dataItem aggregate="none" name="Storage Name" rollupAggregate="none"><expression>[Storage Assets].[Storage].[Storage Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem name="Manufacturer" aggregate="none" rollupAggregate="none"><expression>[Storage Assets].[Storage].[Manufacturer]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Model" aggregate="none" rollupAggregate="none"><expression>[Storage Assets].[Storage].[Model]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Storage Pool Name" rollupAggregate="none"><expression>[Storage Assets].[Storage Pool].[Storage Pool Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Internal Volume Name" rollupAggregate="none"><expression>[Storage Assets].[Internal Volume].[Internal Volume Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Volume Name" rollupAggregate="none"><expression>[Storage Assets].[Volume].[Volume Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="total" name="Total Allocated Capacity GB"><expression>[Storage Assets].[Internal Volume].[Total Allocated Capacity GB]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="fact"/></XMLAttributes></dataItem><dataItem aggregate="total" name="Total Used Capacity GB"><expression>[Storage Assets].[Internal Volume].[Total Used Capacity GB]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="fact"/></XMLAttributes></dataItem><dataItem aggregate="total" name="NAS Allocated (TB)"><expression>if([Volume Name] is null) THEN ([Total Allocated Capacity GB]/1024) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="SAN Allocated (TB)"><expression>if([Volume Name] is not null) THEN ([Total Allocated Capacity GB]/1024) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="Total SAN and NAS Capacity (TB)"><expression>[NAS Allocated (TB)]+[SAN Allocated (TB)]</expression></dataItem><dataItem aggregate="total" name="Raw Capacity (TB)"><expression>maximum([Storage Assets].[Storage].[Raw Capacity GB]/1024 for [Storage Name])</expression></dataItem><dataItem aggregate="total" name="NAS Free (TB)"><expression>if([Volume Name] is null) THEN (([Total Allocated Capacity GB]/1024)-([Total Used Capacity GB]/1024)) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="SAN Free (TB)"><expression>if([Volume Name] is not null) THEN (([Total Allocated Capacity GB]/1024)-([Total Used Capacity GB]/1024)) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="NAS Free (GB)"><expression>if([Volume Name] is null) THEN (([Total Allocated Capacity GB])-([Total Used Capacity GB])) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="SAN Free (GB)"><expression>if([Volume Name] is not null) THEN (([Total Allocated Capacity GB])-([Total Used Capacity GB])) ELSE (0)</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Volume Name] is null</filterExpression></detailFilter><detailFilter><filterExpression>[Manufacturer]='netapp'</filterExpression></detailFilter></detailFilters></query><query name="Capacity SQL">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.storage_dimension.name as 'Storage Name',
dwh_capacity.storage_dimension.model as 'Model',
dwh_capacity.storage_pool_dimension.name as 'Storage Pool Name',
IF(dwh_capacity.internal_volume_capacity_fact.storageaccesstype='NAS',dwh_capacity.internal_volume_dimension.name, NULL) as 'Internal Volume Name',
IF(dwh_capacity.internal_volume_capacity_fact.storageaccesstype='SAN',dwh_capacity.internal_volume_dimension.name, NULL) as 'Volume Name',
ROUND(dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024,2) as 'Total Allocated Capacity GB',
ROUND(dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024,2) as 'Total Used Capacity GB',
IF(dwh_capacity.internal_volume_capacity_fact.storageaccesstype='NAS', ROUND(dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024/1024,2), 0) as 'NAS Allocated (TB)',
IF(dwh_capacity.internal_volume_capacity_fact.storageaccesstype='SAN', ROUND(dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024/1024,2), 0) as 'SAN Allocated (TB)',
ROUND((dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB*dwh_capacity.internal_volume_capacity_fact.rawToUsableRatio)/1024/1024,2) as 'Raw Capacity (TB)'


FROM dwh_capacity.internal_volume_capacity_fact
JOIN dwh_capacity.storage_dimension
ON dwh_capacity.storage_dimension.tk=dwh_capacity.internal_volume_capacity_fact.storagetk
AND dwh_capacity.storage_dimension.manufacturer='netapp'
JOIN dwh_capacity.storage_pool_dimension
ON dwh_capacity.storage_pool_dimension.tk=dwh_capacity.internal_volume_capacity_fact.storagepooltk
JOIN dwh_capacity.internal_volume_dimension
On dwh_capacity.internal_volume_dimension.tk=dwh_capacity.internal_volume_capacity_fact.internalvolumetk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.internal_volume_capacity_fact.datetk
AND dwh_capacity.date_dimension.latest=1

GROUP BY dwh_capacity.storage_dimension.tk, dwh_capacity.storage_pool_dimension.tk, dwh_capacity.internal_volume_dimension.tk


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Model"/><mdProjectedItem name="Storage Pool Name"/><mdProjectedItem name="Internal Volume Name"/><mdProjectedItem name="Volume Name"/><mdProjectedItem name="Total Allocated Capacity GB"/><mdProjectedItem name="Total Used Capacity GB"/><mdProjectedItem name="NAS Allocated (TB)"/><mdProjectedItem name="SAN Allocated (TB)"/><mdProjectedItem name="Raw Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem aggregate="none" name="Storage Name" rollupAggregate="none"><expression>[SQL1].[Storage Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Storage Pool Name" rollupAggregate="none"><expression>[SQL1].[Storage Pool Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Internal Volume Name" rollupAggregate="none"><expression>[SQL1].[Internal Volume Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="none" name="Volume Name" rollupAggregate="none"><expression>[SQL1].[Volume Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="3"/><XMLAttribute name="RS_dataUsage" output="no" value="attribute"/></XMLAttributes></dataItem><dataItem aggregate="total" name="Total Allocated Capacity GB"><expression>[SQL1].[Total Allocated Capacity GB]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="fact"/></XMLAttributes></dataItem><dataItem aggregate="total" name="Total Used Capacity GB"><expression>[SQL1].[Total Used Capacity GB]</expression><XMLAttributes><XMLAttribute name="RS_dataType" output="no" value="2"/><XMLAttribute name="RS_dataUsage" output="no" value="fact"/></XMLAttributes></dataItem><dataItem aggregate="total" name="NAS Allocated (TB)"><expression>[SQL1].[NAS Allocated (TB)]</expression></dataItem><dataItem aggregate="total" name="SAN Allocated (TB)"><expression>[SQL1].[SAN Allocated (TB)]</expression></dataItem><dataItem aggregate="total" name="Total SAN and NAS Capacity (TB)"><expression>[NAS Allocated (TB)]+[SAN Allocated (TB)]</expression></dataItem><dataItem aggregate="total" name="Raw Capacity (TB)"><expression>[SQL1].[Raw Capacity (TB)]</expression></dataItem><dataItem aggregate="total" name="NAS Free (TB)"><expression>if([Volume Name] is null) THEN (([Total Allocated Capacity GB]/1024)-([Total Used Capacity GB]/1024)) ELSE (0)</expression></dataItem><dataItem aggregate="total" name="SAN Free (TB)"><expression>if([Volume Name] is not null) THEN (([Total Allocated Capacity GB]/1024)-([Total Used Capacity GB]/1024)) ELSE (0)</expression></dataItem><dataItem name="Model" aggregate="none" rollupAggregate="none"><expression>[SQL1].[Model]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="NAS Free (GB)"><expression>if([Volume Name] is null) THEN (([Total Allocated Capacity GB])-([Total Used Capacity GB])) ELSE (0)</expression></dataItem><dataItem name="SAN Free (GB)"><expression>if([Volume Name] is not null) THEN (([Total Allocated Capacity GB])-([Total Used Capacity GB])) ELSE (0)</expression></dataItem></selection>
		</query><query name="SAN Volumes SQL">
			<source>
				
			<queryRef refQuery="Capacity SQL"/></source>
			<selection><dataItem name="Storage Name"><expression>[Capacity SQL].[Storage Name]</expression></dataItem><dataItem name="Storage Pool Name"><expression>[Capacity SQL].[Storage Pool Name]</expression></dataItem><dataItem name="Internal Volume Name"><expression>[Capacity SQL].[Internal Volume Name]</expression></dataItem><dataItem name="Volume Name"><expression>[Capacity SQL].[Volume Name]</expression></dataItem><dataItem name="Total Allocated Capacity GB"><expression>[Capacity SQL].[Total Allocated Capacity GB]</expression></dataItem><dataItem name="Total Used Capacity GB"><expression>[Capacity SQL].[Total Used Capacity GB]</expression></dataItem><dataItem name="NAS Allocated (TB)"><expression>[Capacity SQL].[NAS Allocated (TB)]</expression></dataItem><dataItem name="SAN Allocated (TB)"><expression>[Capacity SQL].[SAN Allocated (TB)]</expression></dataItem><dataItem name="Total SAN and NAS Capacity (TB)"><expression>[Capacity SQL].[Total SAN and NAS Capacity (TB)]</expression></dataItem><dataItem name="Raw Capacity (TB)"><expression>[Capacity SQL].[Raw Capacity (TB)]</expression></dataItem><dataItem name="NAS Free (TB)"><expression>[Capacity SQL].[NAS Free (TB)]</expression></dataItem><dataItem name="SAN Free (TB)"><expression>[Capacity SQL].[SAN Free (TB)]</expression></dataItem><dataItem name="Model"><expression>[Capacity SQL].[Model]</expression></dataItem><dataItem name="NAS Free (GB)"><expression>[Capacity SQL].[NAS Free (GB)]</expression></dataItem><dataItem name="SAN Free (GB)"><expression>[Capacity SQL].[SAN Free (GB)]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Volume Name]&lt;&gt;''</filterExpression></detailFilter></detailFilters></query><query name="NAS Volumes SQL">
			<source>
				
			<queryRef refQuery="Capacity SQL"/></source>
			<selection><dataItem name="Storage Name"><expression>[Capacity SQL].[Storage Name]</expression></dataItem><dataItem name="Storage Pool Name"><expression>[Capacity SQL].[Storage Pool Name]</expression></dataItem><dataItem name="Internal Volume Name"><expression>[Capacity SQL].[Internal Volume Name]</expression></dataItem><dataItem name="Volume Name"><expression>[Capacity SQL].[Volume Name]</expression></dataItem><dataItem name="Total Allocated Capacity GB"><expression>[Capacity SQL].[Total Allocated Capacity GB]</expression></dataItem><dataItem name="Total Used Capacity GB"><expression>[Capacity SQL].[Total Used Capacity GB]</expression></dataItem><dataItem name="NAS Allocated (TB)"><expression>[Capacity SQL].[NAS Allocated (TB)]</expression></dataItem><dataItem name="SAN Allocated (TB)"><expression>[Capacity SQL].[SAN Allocated (TB)]</expression></dataItem><dataItem name="Total SAN and NAS Capacity (TB)"><expression>[Capacity SQL].[Total SAN and NAS Capacity (TB)]</expression></dataItem><dataItem name="Raw Capacity (TB)"><expression>[Capacity SQL].[Raw Capacity (TB)]</expression></dataItem><dataItem name="NAS Free (TB)"><expression>[Capacity SQL].[NAS Free (TB)]</expression></dataItem><dataItem name="SAN Free (TB)"><expression>[Capacity SQL].[SAN Free (TB)]</expression></dataItem><dataItem name="Model"><expression>[Capacity SQL].[Model]</expression></dataItem><dataItem name="NAS Free (GB)"><expression>[Capacity SQL].[NAS Free (GB)]</expression></dataItem><dataItem name="SAN Free (GB)"><expression>[Capacity SQL].[SAN Free (GB)]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Volume Name] is null</filterExpression></detailFilter></detailFilters></query></queries></report>